{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Particular","Grafico","Geral"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Grafico","index":1,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Particular","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,0,7,2],[8,4,8,5],[0,0,0,5],[1,0,1,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
["EXEMPLO - Demandas de Vitaminas",null,null,null,null,null,null,null," "]
["Limites",null,"Demanda Diária","Número de Dias","Probabilidades","Probabilidades Acumuladas"]
["Inferior","Superior"]
[0,{"$f":"F4*100","v":30},10,30,{"$f":"D4/$D$7","v":0.3},{"$f":"E4","v":0.3}]
[{"$f":"B4+1","v":31},{"$f":"F5*100","v":60},11,30,{"$f":"D5/$D$7","v":0.3},{"$f":"F4+E5","v":0.6}]
[{"$f":"B5+1","v":61},100,12,40,0.4,{"$f":"F5+E6","v":1}]
[null,null,"SOMA",{"$f":"SUM(D4:D6)","v":100},{"$f":"SUM(E4:E6)","v":1}]
[]
["Experimentos ou Tentativas","Números Aleatórios","Demanda",null,"Tabela de Freqüência"]
[1,{"$f":"RANDBETWEEN(0,100)","v":27},{"$f":"VLOOKUP(B10,Matriz_Procura,3)","v":10},null,10,{"$f":"FREQUENCY(C10:C1009,E10:E12)","v":3}]
[2,{"$f":"RANDBETWEEN(0,100)","v":28},10,null,11,3]
[3,25,10,null,12,4]
[4,77,12,null,null,0]
[5,90,12]
[6,34,11]
[7,38,11]
[8,75,12]
[9,76,12]
[10,59,11]

{"sheet":"Geral","index":2,"n_rows":1009,"n_cols":9,"rows_kept":1009,"cut":false,"hidden":false,"merged":[[8,4,8,5],[7,0,7,2],[0,0,0,5],[1,0,1,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
["EXEMPLO - Demandas de Vitaminas",null,null,null,null,null,null,null," "]
["Limites",null,"Demanda Diária","Número de Dias","Probabilidades","Probabilidades Acumuladas",null,"máximo",{"$f":"MAX(C10:C1009)","v":12}]
["Inferior","Superior",null,null,null,null,null,"mínimo",{"$f":"MIN(C10:C1009)","v":10}]
[0,{"$f":"F4*100","v":30},10,30,{"$f":"D4/$D$7","v":0.3},{"$f":"E4","v":0.3},null,"média",{"$f":"AVERAGE(C10:C1009)","v":11.086}]
[{"$f":"B4+1","v":31},{"$f":"F5*100","v":60},11,30,{"$f":"D5/$D$7","v":0.3},{"$f":"F4+E5","v":0.6},null,"mediana",{"$f":"MEDIAN(C10:C1009)","v":11}]
[{"$f":"B5+1","v":61},100,12,40,0.4,{"$f":"F5+E6","v":1},null,"desvio padrão",{"$f":"_xlfn.STDEV.P(C10:C1009)","v":0.82377424091798102}]
[null,null,"SOMA",{"$f":"SUM(D4:D6)","v":100},{"$f":"SUM(E4:E6)","v":1},null,null,"contador de Simulação",1000]
["Número de simulaçãoes a serem feitas:",null,null,"1000"]
["Experimentos ou Tentativas","Números Aleatórios","Demandas",null,"Tabela de Freqüência",null,2]
[1,5,10,null,10,{"$f":"FREQUENCY(C10:C1009,E10:E12)","v":300}]
[2,67,12,null,11,314]
[3,10,10,null,12,386]
[4,33,11,null,">12",0]
[5,77,12]
[6,3,10]
[7,72,12]
[8,69,12]
[9,34,11]
[10,66,12]
[11,6,10]
[12,21,10]
[13,36,11]
[14,7,10]
[15,67,12]
[16,9,10]
[17,83,12]
[18,57,11]
[19,69,12]
[20,73,12]
[21,10,10]
[22,41,11]
[23,41,11]
[24,2,10]
[25,9,10]
[26,18,10]
[27,17,10]
[28,83,12]
[29,71,12]
[30,44,11]
[31,33,11]
[32,81,12]
[33,59,11]
[34,59,11]
[35,71,12]
[36,38,11]
[37,2,10]
[38,8,10]
[39,8,10]
[40,0,10]
[41,18,10]
[42,73,12]
[43,4,10]
[44,72,12]
[45,55,11]
[46,38,11]
[47,7,10]
[48,86,12]
[49,63,12]
[50,84,12]
[51,88,12]
[52,14,10]
[53,91,12]
[54,94,12]
[55,98,12]
[56,84,12]
[57,5,10]
[58,1,10]
[59,50,11]
[60,38,11]
[61,37,11]
[62,45,11]
[63,27,10]
[64,8,10]
[65,50,11]
[66,65,12]
[67,16,10]
[68,15,10]
[69,36,11]
[70,16,10]
[71,65,12]
[72,96,12]
[73,37,11]
[74,1,10]
[75,64,12]
[76,58,11]
[77,92,12]
[78,41,11]
[79,59,11]
[80,53,11]
[81,0,10]
[82,63,12]
[83,75,12]
[84,78,12]
[85,24,10]
[86,13,10]
[87,84,12]
[88,6,10]
[89,7,10]
[90,93,12]
[91,79,12]
[92,31,11]
[93,17,10]
[94,31,11]
[95,91,12]
[96,51,11]
[97,18,10]
[98,63,12]
[99,11,10]
[100,67,12]
[101,68,12]
[102,52,11]
[103,57,11]
[104,7,10]
[105,32,11]
[106,27,10]
[107,54,11]
[108,83,12]
[109,37,11]
[110,43,11]
[111,38,11]
[112,61,12]
[113,35,11]
[114,74,12]
[115,94,12]
[116,69,12]
[117,2,10]
[118,25,10]
[119,13,10]
[120,20,10]
[121,55,11]
[122,74,12]
[123,70,12]
[124,64,12]
[125,1,10]
[126,30,10]
[127,40,11]
[128,64,12]
[129,6,10]
[130,30,10]
[131,21,10]
[132,98,12]
[133,88,12]
[134,47,11]
[135,2,10]
[136,89,12]
[137,43,11]
[138,30,10]
[139,37,11]
[140,50,11]
[141,82,12]
[142,72,12]
[143,60,11]
[144,65,12]
[145,10,10]
[146,93,12]
[147,12,10]
[148,91,12]
[149,14,10]
[150,59,11]
[151,2,10]
[152,82,12]
[153,89,12]
[154,20,10]
[155,88,12]
[156,40,11]
[157,79,12]
[158,71,12]
[159,89,12]
[160,98,12]
[161,52,11]
[162,46,11]
[163,12,10]
[164,11,10]
[165,89,12]
[166,28,10]
[167,14,10]
[168,93,12]
[169,10,10]
[170,89,12]
[171,81,12]
[172,62,12]
[173,17,10]
[174,56,11]
[175,41,11]
[176,18,10]
[177,63,12]
[178,99,12]
[179,93,12]
[180,46,11]
[181,51,11]
[182,43,11]
[183,66,12]
[184,42,11]
[185,50,11]
[186,10,10]
[187,99,12]
[188,64,12]
[189,43,11]
[190,81,12]
[191,56,11]
[192,7,10]
[193,98,12]
[194,87,12]
[195,50,11]
[196,9,10]
[197,60,11]
[198,22,10]
[199,9,10]
[200,73,12]
[201,75,12]
[202,80,12]
[203,51,11]
[204,22,10]
[205,32,11]
[206,24,10]
[207,97,12]
[208,72,12]
[209,36,11]
[210,71,12]
[211,4,10]
[212,37,11]
[213,3,10]
[214,5,10]
[215,20,10]
[216,55,11]
[217,78,12]
[218,22,10]
[219,68,12]
[220,36,11]
[221,82,12]
[222,89,12]
[223,55,11]
[224,44,11]
[225,84,12]
[226,33,11]
[227,1,10]
[228,95,12]
[229,92,12]
[230,59,11]
[231,2,10]
[232,82,12]
[233,77,12]
[234,83,12]
[235,11,10]
[236,33,11]
[237,18,10]
[238,4,10]
[239,43,11]
[240,81,12]
[241,70,12]
[242,85,12]
[243,11,10]
[244,68,12]
[245,62,12]
[246,73,12]
[247,82,12]
[248,74,12]
[249,15,10]
[250,35,11]
[251,62,12]
[252,62,12]
[253,88,12]
[254,23,10]
[255,1,10]
[256,63,12]
[257,51,11]
[258,61,12]
[259,29,10]
[260,72,12]
[261,75,12]
[262,65,12]
[263,10,10]
[264,73,12]
[265,58,11]
[266,75,12]
[267,29,10]
[268,99,12]
[269,66,12]
[270,23,10]
[271,94,12]
[272,98,12]
[273,6,10]
[274,21,10]
[275,77,12]
[276,42,11]
[277,18,10]
[278,76,12]
[279,65,12]
[280,51,11]
[281,0,10]
[282,26,10]
[283,45,11]
[284,44,11]
[285,51,11]
[286,10,10]
[287,11,10]
[288,17,10]
[289,39,11]
[290,50,11]
[291,1,10]
[292,43,11]
[293,1,10]
[294,71,12]
[295,48,11]
[296,0,10]
[297,58,11]
[298,35,11]
[299,69,12]
[300,22,10]
[301,67,12]
[302,11,10]
[303,67,12]
[304,76,12]
[305,83,12]
[306,57,11]
[307,71,12]
[308,62,12]
[309,61,12]
[310,41,11]
[311,86,12]
[312,40,11]
[313,75,12]
[314,74,12]
[315,83,12]
[316,85,12]
[317,62,12]
[318,79,12]
[319,1,10]
[320,58,11]
[321,90,12]
[322,77,12]
[323,82,12]
[324,11,10]
[325,60,11]
[326,2,10]
[327,32,11]
[328,15,10]
[329,18,10]
[330,40,11]
[331,97,12]
[332,6,10]
[333,10,10]
[334,94,12]
[335,77,12]
[336,68,12]
[337,42,11]
[338,70,12]
[339,56,11]
[340,30,10]
[341,83,12]
[342,96,12]
[343,61,12]
[344,94,12]
[345,80,12]
[346,56,11]
[347,42,11]
[348,88,12]
[349,11,10]
[350,58,11]
[351,85,12]
[352,39,11]
[353,43,11]
[354,21,10]
[355,38,11]
[356,80,12]
[357,41,11]
[358,88,12]
[359,76,12]
[360,71,12]
[361,79,12]
[362,69,12]
[363,78,12]
[364,54,11]
[365,87,12]
[366,1,10]
[367,39,11]
[368,28,10]
[369,24,10]
[370,39,11]
[371,99,12]
[372,51,11]
[373,73,12]
[374,70,12]
[375,4,10]
[376,66,12]
[377,56,11]
[378,52,11]
[379,88,12]
[380,56,11]
[381,88,12]
[382,76,12]
[383,79,12]
[384,15,10]
[385,40,11]
[386,60,11]
[387,35,11]
[388,53,11]
[389,38,11]
[390,57,11]
[391,97,12]
[392,23,10]
[393,80,12]
[394,0,10]
[395,79,12]
[396,69,12]
[397,88,12]
[398,61,12]
[399,69,12]
[400,8,10]
[401,71,12]
[402,42,11]
[403,65,12]
[404,26,10]
[405,22,10]
[406,91,12]
[407,32,11]
[408,10,10]
[409,44,11]
[410,38,11]
[411,86,12]
[412,93,12]
[413,86,12]
[414,60,11]
[415,0,10]
[416,38,11]
[417,21,10]
[418,72,12]
[419,37,11]
[420,33,11]
[421,38,11]
[422,37,11]
[423,11,10]
[424,22,10]
[425,64,12]
[426,11,10]
[427,66,12]
[428,54,11]
[429,4,10]
[430,1,10]
[431,84,12]
[432,61,12]
[433,21,10]
[434,57,11]
[435,20,10]
[436,60,11]
[437,22,10]
[438,87,12]
[439,61,12]
[440,77,12]
[441,83,12]
[442,93,12]
[443,2,10]
[444,2,10]
[445,93,12]
[446,38,11]
[447,62,12]
[448,60,11]
[449,26,10]
[450,34,11]
[451,11,10]
[452,22,10]
[453,34,11]
[454,56,11]
[455,33,11]
[456,21,10]
[457,69,12]
[458,80,12]
[459,2,10]
[460,12,10]
[461,26,10]
[462,50,11]
[463,97,12]
[464,42,11]
[465,17,10]
[466,63,12]
[467,30,10]
[468,56,11]
[469,62,12]
[470,86,12]
[471,5,10]
[472,23,10]
[473,15,10]
[474,95,12]
[475,1,10]
[476,85,12]
[477,2,10]
[478,39,11]
[479,81,12]
[480,36,11]
[481,97,12]
[482,26,10]
[483,23,10]
[484,24,10]
[485,17,10]
[486,42,11]
[487,78,12]
[488,75,12]
[489,37,11]
[490,86,12]
[491,55,11]
[492,46,11]
[493,44,11]
[494,35,11]
[495,26,10]
[496,2,10]
[497,98,12]
[498,36,11]
[499,60,11]
[500,16,10]
[501,34,11]
[502,16,10]
[503,80,12]
[504,98,12]
[505,80,12]
[506,23,10]
[507,49,11]
[508,46,11]
[509,1,10]
[510,91,12]
[511,73,12]
[512,19,10]
[513,74,12]
[514,26,10]
[515,37,11]
[516,43,11]
[517,75,12]
[518,23,10]
[519,63,12]
[520,36,11]
[521,9,10]
[522,5,10]
[523,90,12]
[524,60,11]
[525,48,11]
[526,85,12]
[527,86,12]
[528,95,12]
[529,5,10]
[530,56,11]
[531,75,12]
[532,44,11]
[533,27,10]
[534,5,10]
[535,3,10]
[536,58,11]
[537,19,10]
[538,54,11]
[539,12,10]
[540,88,12]
[541,83,12]
[542,21,10]
[543,54,11]
[544,61,12]
[545,97,12]
[546,11,10]
[547,20,10]
[548,81,12]
[549,1,10]
[550,28,10]
[551,2,10]
[552,57,11]
[553,25,10]
[554,18,10]
[555,72,12]
[556,56,11]
[557,30,10]
[558,28,10]
[559,91,12]
[560,74,12]
[561,79,12]
[562,0,10]
[563,42,11]
[564,42,11]
[565,33,11]
[566,82,12]
[567,88,12]
[568,54,11]
[569,72,12]
[570,67,12]
[571,55,11]
[572,14,10]
[573,38,11]
[574,59,11]
[575,38,11]
[576,15,10]
[577,7,10]
[578,59,11]
[579,37,11]
[580,41,11]
[581,85,12]
[582,84,12]
[583,13,10]
[584,92,12]
[585,26,10]
[586,0,10]
[587,68,12]
[588,38,11]
[589,80,12]
[590,92,12]
[591,59,11]
[592,92,12]
[593,61,12]
[594,47,11]
[595,26,10]
[596,15,10]
[597,42,11]
[598,74,12]
[599,52,11]
[600,40,11]
[601,80,12]
[602,40,11]
[603,44,11]
[604,27,10]
[605,56,11]
[606,31,11]
[607,43,11]
[608,35,11]
[609,45,11]
[610,49,11]
[611,55,11]
[612,27,10]
[613,17,10]
[614,20,10]
[615,9,10]
[616,93,12]
[617,52,11]
[618,32,11]
[619,42,11]
[620,8,10]
[621,88,12]
[622,5,10]
[623,4,10]
[624,2,10]
[625,90,12]
[626,75,12]
[627,93,12]
[628,64,12]
[629,45,11]
[630,11,10]
[631,10,10]
[632,70,12]
[633,85,12]
[634,50,11]
[635,45,11]
[636,31,11]
[637,27,10]
[638,67,12]
[639,83,12]
[640,74,12]
[641,51,11]
[642,59,11]
[643,37,11]
[644,41,11]
[645,88,12]
[646,63,12]
[647,7,10]
[648,14,10]
[649,45,11]
[650,90,12]
[651,61,12]
[652,71,12]
[653,46,11]
[654,95,12]
[655,43,11]
[656,58,11]
[657,8,10]
[658,62,12]
[659,8,10]
[660,94,12]
[661,33,11]
[662,18,10]
[663,77,12]
[664,96,12]
[665,25,10]
[666,76,12]
[667,23,10]
[668,28,10]
[669,44,11]
[670,94,12]
[671,74,12]
[672,85,12]
[673,67,12]
[674,68,12]
[675,51,11]
[676,87,12]
[677,89,12]
[678,42,11]
[679,22,10]
[680,8,10]
[681,44,11]
[682,54,11]
[683,89,12]
[684,29,10]
[685,44,11]
[686,91,12]
[687,90,12]
[688,13,10]
[689,56,11]
[690,86,12]
[691,37,11]
[692,7,10]
[693,95,12]
[694,26,10]
[695,70,12]
[696,70,12]
[697,43,11]
[698,96,12]
[699,43,11]
[700,22,10]
[701,95,12]
[702,41,11]
[703,31,11]
[704,22,10]
[705,32,11]
[706,52,11]
[707,61,12]
[708,68,12]
[709,11,10]
[710,86,12]
[711,71,12]
[712,27,10]
[713,90,12]
[714,1,10]
[715,93,12]
[716,85,12]
[717,72,12]
[718,21,10]
[719,62,12]
[720,19,10]
[721,73,12]
[722,25,10]
[723,45,11]
[724,7,10]
[725,23,10]
[726,62,12]
[727,3,10]
[728,48,11]
[729,78,12]
[730,89,12]
[731,72,12]
[732,16,10]
[733,72,12]
[734,35,11]
[735,71,12]
[736,36,11]
[737,87,12]
[738,90,12]
[739,34,11]
[740,87,12]
[741,43,11]
[742,21,10]
[743,68,12]
[744,26,10]
[745,24,10]
[746,8,10]
[747,39,11]
[748,42,11]
[749,21,10]
[750,11,10]
[751,73,12]
[752,30,10]
[753,2,10]
[754,57,11]
[755,98,12]
[756,96,12]
[757,7,10]
[758,54,11]
[759,93,12]
[760,81,12]
[761,71,12]
[762,32,11]
[763,75,12]
[764,12,10]
[765,66,12]
[766,4,10]
[767,9,10]
[768,82,12]
[769,73,12]
[770,61,12]
[771,34,11]
[772,47,11]
[773,77,12]
[774,77,12]
[775,30,10]
[776,57,11]
[777,87,12]
[778,56,11]
[779,91,12]
[780,3,10]
[781,82,12]
[782,92,12]
[783,41,11]
[784,99,12]
[785,81,12]
[786,61,12]
[787,62,12]
[788,78,12]
[789,38,11]
[790,30,10]
[791,55,11]
[792,23,10]
[793,63,12]
[794,3,10]
[795,18,10]
[796,15,10]
[797,67,12]
[798,78,12]
[799,60,11]
[800,12,10]
[801,31,11]
[802,42,11]
[803,28,10]
[804,52,11]
[805,3,10]
[806,81,12]
[807,71,12]
[808,73,12]
[809,19,10]
[810,20,10]
[811,15,10]
[812,72,12]
[813,45,11]
[814,91,12]
[815,80,12]
[816,79,12]
[817,52,11]
[818,14,10]
[819,3,10]
[820,56,11]
[821,7,10]
[822,19,10]
[823,4,10]
[824,26,10]
[825,95,12]
[826,81,12]
[827,66,12]
[828,26,10]
[829,65,12]
[830,84,12]
[831,40,11]
[832,80,12]
[833,0,10]
[834,12,10]
[835,82,12]
[836,3,10]
[837,12,10]
[838,61,12]
[839,8,10]
[840,27,10]
[841,60,11]
[842,81,12]
[843,78,12]
[844,52,11]
[845,1,10]
[846,35,11]
[847,5,10]
[848,23,10]
[849,56,11]
[850,95,12]
[851,86,12]
[852,32,11]
[853,4,10]
[854,48,11]
[855,57,11]
[856,45,11]
[857,7,10]
[858,43,11]
[859,85,12]
[860,50,11]
[861,52,11]
[862,49,11]
[863,65,12]
[864,39,11]
[865,23,10]
[866,48,11]
[867,60,11]
[868,6,10]
[869,94,12]
[870,46,11]
[871,56,11]
[872,73,12]
[873,52,11]
[874,15,10]
[875,45,11]
[876,45,11]
[877,41,11]
[878,54,11]
[879,34,11]
[880,85,12]
[881,32,11]
[882,81,12]
[883,76,12]
[884,11,10]
[885,19,10]
[886,46,11]
[887,29,10]
[888,31,11]
[889,39,11]
[890,68,12]
[891,41,11]
[892,89,12]
[893,18,10]
[894,3,10]
[895,50,11]
[896,42,11]
[897,39,11]
[898,29,10]
[899,29,10]
[900,62,12]
[901,41,11]
[902,64,12]
[903,31,11]
[904,64,12]
[905,35,11]
[906,1,10]
[907,81,12]
[908,56,11]
[909,55,11]
[910,75,12]
[911,80,12]
[912,16,10]
[913,23,10]
[914,52,11]
[915,39,11]
[916,95,12]
[917,44,11]
[918,41,11]
[919,36,11]
[920,39,11]
[921,33,11]
[922,35,11]
[923,98,12]
[924,47,11]
[925,53,11]
[926,73,12]
[927,12,10]
[928,41,11]
[929,89,12]
[930,34,11]
[931,53,11]
[932,74,12]
[933,42,11]
[934,43,11]
[935,48,11]
[936,52,11]
[937,50,11]
[938,17,10]
[939,52,11]
[940,86,12]
[941,34,11]
[942,27,10]
[943,60,11]
[944,72,12]
[945,67,12]
[946,85,12]
[947,42,11]
[948,87,12]
[949,69,12]
[950,61,12]
[951,93,12]
[952,21,10]
[953,29,10]
[954,20,10]
[955,24,10]
[956,26,10]
[957,48,11]
[958,88,12]
[959,65,12]
[960,91,12]
[961,13,10]
[962,39,11]
[963,0,10]
[964,47,11]
[965,88,12]
[966,10,10]
[967,23,10]
[968,91,12]
[969,37,11]
[970,41,11]
[971,23,10]
[972,40,11]
[973,69,12]
[974,37,11]
[975,90,12]
[976,4,10]
[977,7,10]
[978,57,11]
[979,49,11]
[980,91,12]
[981,85,12]
[982,33,11]
[983,15,10]
[984,31,11]
[985,67,12]
[986,3,10]
[987,83,12]
[988,30,10]
[989,95,12]
[990,75,12]
[991,25,10]
[992,44,11]
[993,53,11]
[994,24,10]
[995,34,11]
[996,82,12]
[997,71,12]
[998,95,12]
[999,72,12]
[1000,35,11]